<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="bf20941">CHECKPOINT</title><body><p id="sql_command_desc">Forces a transaction log checkpoint.</p><section id="section2"><title>Synopsis</title><codeblock id="sql_command_synopsis">CHECKPOINT</codeblock></section><section id="section3"><title>Description</title><p>A checkpoint is a point in the transaction log sequence at which all
data files have been updated to reflect the information in the log. All
data files will be flushed to disk.</p>
  <p>The <codeph>CHECKPOINT</codeph> command forces an immediate checkpoint when the command is
        issued, without waiting for a regular checkpoint scheduled by the system.
          <codeph>CHECKPOINT</codeph> is not intended for use during normal operation.</p>
  <p>If run during recovery, the <codeph>CHECKPOINT</codeph> command
    will force a restartpoint rather than writing a new checkpoint.</p>
  <p>Only superusers may call <codeph>CHECKPOINT</codeph>.</p></section><section id="section4"><title>Compatibility</title><p>The <codeph>CHECKPOINT</codeph> command is a Greenplum Database
extension.</p></section></body></topic>
